Import Fees

Import fees into CAMA.

The imported information displays in the Parcel record > Assessments tab > Fees panel.

Prerequisites

Fees Import permission is required to run this process.

Import fees

  1. From the left-side navigation, select Processes.

  2. Under the Imports section, select Import Fees.

  3. Populate the required fields.

  • Tax Year: Enter the tax year.

  • Import Template: Select an import template type.

  • Fee: Select a fee to import.

  • Choose Import File: Drag and drop or select the file to import.

  1. Select Import.

    The system performs the following validation checks:

    • The column/position of the Map Number (or Primary Parcel ID) is never blank.

    • The Map Number (or Primary Parcel ID) exists with any status.

    • The Map Number is NOT duplicated in the import file.

    • The parcel only occurs once in the import file.

    • The tax assessment year for the parcel must be Open and Unsubmitted.

    • Verify that one and only one of the following is true.

      • The column/position of the Fee Code is not blank, exists under Settings, and is effective for the tax year provided by the user.

      • The user has selected a valid Fee Code, and it is effective for the tax year provided by the user.

    • Verify that one and only one of the following is true.

      • The column/position of the Fee Amount is not blank and converts to a decimal that is between 0 and 10,000,000.00.

      • The column/position of the Fee Multiplier is not blank and converts to an integer that is between 0 and 10,000.

      • If the century is not provided, then 20 is assumed.

    • A column/position that fails this validation causes the row to be considered invalid.

  2. On the Import Fees Log panel, select Refresh.

The completed process displays in the grid and the imported information displays in the Parcel record > Assessments tab > Fees panel.

View fee import errors

After selecting Import, the application validates that the input file is in the correct format and uses proper data types.

  1. In the Import Fees Log panel grid, locate the process.

    The Summary of Results column displays the number of valid rows and the number of rows with errors, if applicable.

  1. To view errors, select the Error Log button.

    The Error Log downloads as an .xlsx file.

    The types of errors are as follows:

  • No Map Number: Parcel Identifier cannot be blank.

  • Parcel Tax Year Not Open: Parcel Assessment Year is not open for updates.

  • Tax Year does not exist for Parcel: Parcel [0001-0002-0003-0005] not found in tax year [Tax Year input].

  • Invalid Fee Amount: Fee Amount must be between 0 and 10,000,000.00.

  • Invalid Fee Multiplier: Fee Multiplier must be between 0 and 10,000.

  • Fee not valid: Fee [Code] is invalid.

  • Fee Multiplier and Amount are blank: Fee Amount or Fee Multiplier is required.

You can now fix the errors and run the import process again.

View process parameters

View the Process Parameters selected for a process.

  1. From the left-side navigation, select Processes.

  2. Under the Imports section, select Import Fees.

  3. Locate the process in the Import Fees Log panel.

  4. Select the expander icon (+) next to the process.

The Process Parameters display.